What type of pump moves the water upward inside of the deep-well pipe?

Usually a submersible. This is a long thin pump near the bottom of the well. Domestic ones are typically 4" round and about 3 feet long and can pump up to 15 gpm to the surface from 200-300 feet down, in a 1" poly/rubber pipe.