I find it annoying there are no beaches or pond water like we had in TS2. Maybe this will come!
I made a set of water terrains to enhance my game. Included are two rocky stream water terrains, a muddy puddle creek, and two algae water terrains. Might not look great over a large area, but if you are building a pond, they look realistic around the edges. I use the muddy puddle a lot in my gardens to add texture and depth. Seamless and repeating with no hard edges.