My understanding is that as of right now there is no method available to add additional sounds to the game to be used by addons.
Source
However, there is a function in the ESO API called "PlaySound(string soundName)" which should allow addons to play sounds already existing in the game. You'd just need to find one suitable for a chat notification.