Water runs in underground pipes that can be 4 to 5 feet underground or more. It is brought to the surface with a riser. Most of our parks have a meter pit (or well) which is a 5’ deep hole in the ground with a corrugated plastic liner around it roughly 18" in diameter. See attached photo looking into the pit. A water line would be run from the meter to the home and must be heated and insulated.
We also use the Woodford Thermaline water riser in one of our Fort Wayne parks, which another person already posted. With this system, the riser is electrically heated so prevent freezing and the water line to the home is run to this device. Our plumber used to charge $1,000 to install the Thermaline riser for labor and materials. We now buy the materials from another source which saved about $200.
If you plan to do this work yourself, be prepared to dig a deep hole with heavy machinery, install all of the components, and tap them into your main water line. Reaching into the pit can be dangerous because you can get stuck in the confined space and suffocate. Also, if you are replacing leaking risers, the ground can be soft like quicksand as you dig. We once lifted a maintenance worker from a meter pit with a fire truck hoist, and fortunately he was not injured.