best places to ride around houston?

I am moving to houston and there are so many places to look at. When you talk to people about riding, I seem to get some conflicting answers for good water. I prefer freshwater, and I like places where there is enough shore to quell the kinetic energy of the wakes from both my boat and others. Any suggestions? Pros and cons for each place? I am thinking about scouting out some places while looking for a house, and any places with high marks will be on my list of places to visit.