I've lived in San Angelo for about 10 years now. There is a steady supply of water, but as with most places, during draught years (which we've only had really one to worry about), they do some water rationing (water lawns only 1-2 times per week and no car washing from homes).
They have been building water towers all around the city (specifically on the southwest side where the majority of new homes are being built).
The pressure had only been a problem for 2 years while they were building up some of the larger homes in the southwest side of the city (an area called The Bluffs), but they have fixed the problems both with infrastructure and a large water tower.
The indigenous water supplied by the city (called "Superior Water") does have a funny taste to it. But there are only a few restaurants that were built that do not have a water reverse osmosis (RO) that filters much of that out. And it's a relatively cheap thing to install in a home your in (I have that and a water softener).
To be honest, Aggie, unless you're living in the outskirts, on a farm, or more rurally, you won't need well water. There are larger tracts of land on the outskirts of the city that do have well water, and I haven't heard of any problems with it.
There is some good information on water utilities at:
San Angelo --}
If you have any other questions, please don't hesitate to ask!!
Rath