XChat-WDK and its successor Hexchat can be configured to make noise when a message is recieved.