This image has a very good illustration of fluids, which is why I chose this image. CG Evers work posted on Leifs blog have some sorts of water form incorporated in his images. The illustration of water is done in detail which inspires me to create something realistic.
To help with my final design, I got help from this link: http://www.youtube.com/watch?v=UioEstpPy0Q
It uses 3d tool so make sure you have a fast running computer.
Using similar techniques, I created water effect on top of the text "water."
And this is the result.