How to know which app is playing a sound?
I was going to suggest WireTap products from Ambrosia

They had the ability to differentiate sounds from different applications, however due to the nature of Lion these products no longer do that and Apples sand boxing requirement is going to make it worse.