http://www.youtube.com/watch?v=uENITui5_jU
Just so everyone knows, only the camera sees the water this way. The naked eye would not see this. Its because the water is oscillating at the same rate as the camera speed.
The main thing to keep in mind for this project is that you need a camera that shoots 24 fps.