The water moves upward in the tube. A surface well collects water in the well casing which is then pumped to the surface. The water would be brought to the surface with a pump. Some wells might be deeper because the water table is deeper. Water wells and oil wells function on the same principles.
Oil wells are usually deeper.
The pressure in the water forces the water to the surface. These are artesian wells. Investigate to discover if your city, school, or home gets its water from a well. Invite an expert in to talk about wells and pumps and how they work. Investigate how water was lifted to the surface before pumps were invented.