Are you looking for waterfront or just near water? You have a few options for waterfront: (1) the big lakes (Conroe, Lake Houston), (2) somewhere near or between Freeport and Galveston on the beach or intracoastal waterway; (3) living in a neighborhood that has an HOA or water-district managed pond or two; or (4) living on a large private property with a pond.
If you're just looking for near water, there are four "neighborhood fishing" ponds that are stocked with catfish in the spring/summer and trout in the winter/spring. They are designed to provide easy access for fishing in residential areas; most should be within 15-30 minutes of a good hospital.
https://tpwd.texas.gov/fishboat/fis...in.phtml#neighborhood-fishin-regulationsLake Woodlands also has some waterfront property, or you can live nearby. It's a 10-minute drive to a hospital.
The Kickerillo-Mischer Preserve a 3-minute drive to a hospital. I've never fished it, but it seems nice.
Welcome to the neighborhood.