This resource is for Vue and won't work in other 3D applications.
This is the base water material I used in this image:[link]
The material on the verticals is displaced, turn that off to speed up your renders.
Also included is an image map and alpha that you can play with to create the foamy texture; on an alpha plane, for example. Try it different ways to see what works with your image and atmosphere.