Like alter said, place the .dem file in your cstrike folder. Path should be:

/Program Files/Steam/SteamApps/youremailaddress/Counter Strike Source/cstrike

You can type the playdemo commmand into consol, or type demoui to bring up a menu where you can load it (or any other demo for that matter) and watch it.