Steam beta now has a sound for achievements, here's a video with it

Cute!

Could be wrong but I believe this is only in steam big picture mode.

Edit: we definitely have a little noise now not in big picture mode.