I helped hand-dig my parents well circa 1953 in what was then rural county. It served ample sweet water for decades for house use. It became a square hole about 5x5, and top-of-head deep when breaking through the last 2' of hard pan, into the water table below. A shaft was drilled down for a stand pipe, and the standard pump/pressure tank/connectors etc was installed.
Into the late 60s it was active with no issue from the county health dept. As the city limits overtook the area, of course more bureaucrats became preoccupied with making sure their sovereign territory was properly administrated, so a increasingly hostile multi decade argument ensued. Finally the city demanded the folks hook up to the city water pipes now running down the center of the street.
The folks got a new well professionally drilled just before the grandfather clause expired on such facilities. The complexities over the next couple decades kept them busy, as some years they would disconnect from city water, and some years reconnect.
Finally it grew to expensive and legally cumbersome, and they abandoned their home wells, like good little subjects.
My own home has a private well, but we sit in the county, not the city, which has no say as of yet.
Look into the regulations the local bureaucrats seek to impose upon you, as they will do their utmost to see you comply, regardless of any reason you may attempt to use in justifying your well.
Along with your city water supply is anything they put in it whether you want it or not. Their argument is your ground water has stuff in it too.
In any case, be prepared for legal costs as well as direct well/pump costs, should you pursue your private well plan. Good luck.
