This is my try to create realistic water with some foam and spray.
Which material node setups do you use for water?