Following the excellent guide by Snipergen a prefab that I picked up somewhere, I easily added a moving texture. Problem is however, both of the pictures I used look really crappy 
http://i249.photobucket.com/albums/gg204/Immortal-D/Best of TF2/waterproblem1.jpg
http://i249.photobucket.com/albums/gg204/Immortal-D/Best of TF2/waterproblem2.jpg
The first is the default water from Hydro, and the second is a random picture I found. I can post the vmf if it will help. How the heck do you create a water picture/texture that's actually light, see-through, foam, etc.?
http://i249.photobucket.com/albums/gg204/Immortal-D/Best of TF2/waterproblem1.jpg
http://i249.photobucket.com/albums/gg204/Immortal-D/Best of TF2/waterproblem2.jpg
The first is the default water from Hydro, and the second is a random picture I found. I can post the vmf if it will help. How the heck do you create a water picture/texture that's actually light, see-through, foam, etc.?