Guillaume Kurkdjian Water Material Guillaume Kurkdjian has this really cool water:

How can I achieve this water in blender cycles? (material and modeling of the water)

The closest I've gotten is this:



This is the material settings for the image above:
Here is a try:



Analysis:

According to the source artwork, there may be some shaders used. However, the key parts can be: Glass/Refraction, Translucent, Glossy, etc.

So after a few trial and errors, a possible setup might be:



Besides, post processing like compositing can also be included:



To model the water shape, here is one way:


Example file: