If you're editing the Normal profile, there is a line for "Play sound". You can choose In Holster, Out of Holster, or Always. That's the limit for it though.

You can create a custom profile though and set it up any way you want.