Water pixelates only when animals touch it, horses, dogs, any animal. With NPCs or Arthur Morgan it is not the same, water behaves realistically.
https://socialclub.rockstargames.com/photos/?dateRange=last7&filter=me&platform=pc&sort=likes&title=...
It's on the known issues in current driver release notes, so being looked into.