Not sure if this is what you are after, but the OOTB material library ships with a water material that renders with "waves".
Do you want custom texture map or out of the box (OOTB) Revit texture? If you want the OOTB, choose the liquid
If you want custom texture, you can download texture from the link below
https://3dtextures.me/category/water/
https://www.cadhatch.com/seamless-water-textures
Thanks, but I am using the OOTB water, it renders smooth as glass. In Enscape. I don't see a way to modify it there.
https://drive.google.com/file/d/1PMQdPG4phseCrILhIo0KZ-LjVBUy9ckL/view?usp=drivesdk
Try indoor pool and see if you get the effect.