There are many water sims you may come across on Reddit, but this one by a developer known as AshenOneArt is seriously impressive. You can try it yourself by getting HPWater on GitHub, or watch another demo below:
Unfortunately, the developer hasn't shared many details about this project. However, if you're looking for a solution to create realistic, dynamic water environments in Unity, you might want to check out kripto289's KWS2 Dynamic Water System. The tool is actively updated, and there's a free demo for users to test: