I've tried to re-create it too. It's not easy. I used layered shader: one layer for the actual water and another layer for the foam. Lighting plays a big role on the looks as always. The shader I created looks crap in a different kind of lighting setup. All it takes is days of tweaking and loads of test renders

Here's my results:
https://kotisivu.mtv3.fi/karppa/anim/...1-3Preview.zip