The title pretty much covers the question, but let me expand a bit:
Does water cooling just make cool water flow around the tubes in your computer, therefore cooling the air around the tubes? Just like if your holding your hand next to a cup of ice, you can feel like coolness. But in this case your hand is say, your graphic card - and the cup of ice is the tube of water?