It depends on the well. Many cities rely on wells for water. Low pressure is not the norm, or at least need not be. Filters and/or other conditioning is not a given. Get the water tested before you buy. Make sure you have a proper well record so you know what's down the hole.
IMHO, the cost of monthly water bills would likely be higher than the cost to have your own well.