On Linux you can do it with ‘dunst’.
It can be configured to play different sounds depending on notifiction text.