The water rises in the tubes because of capillary action... this is where the liquid is more attracted to the solid walls then the rest of the liquid.

My educated guess is that if the tube is short enough and the water flows over the top and back into a bowl, one would find over time that the water cools.