Board Thread:Support Requests - Getting Technical/@comment-4879294-20140720061026/@comment-7697305-20140720062247

ChatHacks sounds what you are looking for, considering it has an option to set keywords (defaults to just your full username) which will play a sound for you when they are typed in chat.

If you want to install it for yourself on a particular wiki, you would create Special:Mypage/wikia.js on the wiki in question with the following code as its content:

I believe you can create Special:Mypage/global.js on Community Central with the same content if you want ChatHacks enabled on all wikis you go to, but I haven't done that before, so I don't know if you would need to do anything else to make it work.

Edit: Note that ChatHacks only works if you join chat from a chat module created with (ie. modules that shows up to the right of pages like Special:WikiActivity).