Disable notification sounds but keep SMS Sounds
A partial solution is to create a silent notification sound and use it as default, and then set custom notification sounds in each of the apps you use, assuming that the apps allow you to choose your notification sound. Most stock SMS apps and WhatsApp allow this, but the latest version of Skype does not.