I've taken sound effects from EverQuest, Doom, F.E.A.R., WoW, and Neverwinter Nights (as well as few oddball ones here and there) and used them for my games. I use a program called Audacity when I want to mix a loop (prepared before the game, naturally).
To play the sounds, I use VLC Media...