Hi Ben,
Thanks for the information. Just in case anyone else wants to follow, I re-arranged the sketch from above and tested it even in R18/Studio.
Project file, Screencapture
https://www.amazon.com/clouddrive/share/D4tqde7KKoQGrNGP6UqoA8spfruniAjzc2mYeAeIkI2
The idea is to use motion blur to get as close as possible to the effect of the water. The appearance of water is mainly based on light, either as reflection or refraction. Water itself without anything else (outside information) will be invisible, including air bubbles, etc. The idea is, to mimic this as much as possible. The Reflection and Refraction part is excluded, as with Sub-Frame Motion Blur, that will be a longer render. Decide for yourself if the render time wouldn’t be an obstacle.
Please note that the Camera settings will have a massive impact on the results. Try 1/4 sec or even other times as well.
I’m aware that this is more a sketch than a perfect simulation, but I tried to keep it simple.
ENJOY