For those two particular apps, you can for Twitter but not for Instagram (it's on each app's Settings). But that's with your 'stock' options. If you download a notification manager app, like LightFlow, you CAN assign different notification sounds and lights (if your phone supports it) to each app.