I mader this photoreal water shader with foam, spray, caustics and godrays all procedurally in Blender.
Check out the following link to learn more: