Hello there. Have you ever played on the server before work and had "My Hump" stuck in your head all day because of it? Would you rather have something else playing at the end of the map? Here's how I did it. This is for Windows, but works similiarly in Mac and Linux.
(I just want to point out that Reddman actually did this before me, which inspired me to do it as well)
First you need to get a clip of what you want, whether it's a .wav file or .mp3. If it's a song and you want to get a clip of what you want, you need an editor. I used Audacity, which is free and you can get it here at sourceforge
http://audacity.sourceforge.net/download/windows.
In Audacity, open the song you want, find like 20 to 30 seconds of what you'd like playing, highlight it and crop it out. Export it as an .mp3 (in the File dropdown menu). Save it with the filename as the song you'd like to replace, i.e. myhump.mp3.
You can find the names of the songs on the server by going here: C:\Program Files\Steam\steamapps\$User\counter-strike source\cstrike\sound\gungame
After you create your .mp3 files and name them appropriately, move them into this gungame folder. It should warn you that there are already files with that name and ask you if you'd like to overwrite them. You do want to overwrite them.
And that's it. Next time you get to the end of a map your sound should play.
If any of what I said wasn't clear, please post here. I'm not great at writing tutorials.