Try Ringneck Creek. It’s a pretty active spot. It’s the spot where you go fishing with Javier in the story mode.

Not a specific location, but if there's a lot of ripples in the water that usually means that there's fish in it.