mIRC does do that.
to enable that feature type /sound on and hit the enter key, in a mIRC window (channel area where you type to talk)