I have a plugin that does this and other effects (each of which can be turned off):
Setups currently are only triggered by deaths, but I could add damage as a separate trigger for each setup - playing sounds on every player damage event would have more of an impact on CPU though. Additionally, I would need to add an edit to allow specifying specific steam IDs, per your post, but that isnt too bad.
Clarifying Note: When you say it plays a sound, I assume you dont mean it removes the normal server sounds for bullet impacts, etc. It plays a sound in addition to those.
Additionally,
I have a plugin on alliedmods that only does the sounds, but again is limited to deaths, plays only to the victim and killer, and is limited to one sound path for the killer and one for the victim. It was an expansion of the concept from the "got ya b****" type plugin. Since it is related, I figured I'd mention it as a free alternative or option for others reading this thread in the future.
PM me if you are interested in having me make the above edits, etc.
__________________