Sound notifications really only work on mobile, any other place they are not welcome. Not sure why people keep bumping this, it wil never ever be added for obvious reasons. The only way to have this is by using an app for the phone and make it send a push notification sound. But that would be part of the app features, not the default XF installation.