RF2014, the connectivity-plugin or the render kit don't include water shaders, but there are many examples on the net.

For the internal render engine (AR) of C4D you have several examples for liquids inside C4D (shader presets in the materials menus).... and other free resources, for example http://www.c4davenue.ch/Download.html

For Maxwell and Vray there are entire libraries of free materials on their respective homepages. And don't forget that often the reflection of the environment and lights play the most important role for a realistic look of a water shader.