Honestly there is no good water to be found anywhere close. Conroe is a mess all of the time and the trinity is a long ways away.
I am also in the same situation as you and want some good water but I just dont want to have to drive an hour and a half to get to it every weekend.
Man I sure do miss the intercoastal canal in La where I am from