Did you have a look at the free asset Water Planes from Epic at Marketplace/Learn Tab? Those are quite nice, but they dont have super waves…
In order for any material to work with forward rendering you need to do two steps:
- inside the material, mark at Translucency section, Lighting Mode=Surface ForwardShading
- change the project settings at Engine->Rendering section, Forward Renderer, mark Forward Shading (See below)
Once you mark the option for Forward Rendering all your shaders will be compiled and takes a lot of time, so do not worry, let it do it.
After all is finished you can plug your VR gear and voilá!