Slin's water shader is ok but it would be even better with an alpha channel implemented, so you could see through the water...