Which type of pump is appropraite for my well?
At 115 feet static and 250 bottom your (sensible) options are submersible, submersible, or submersible. 

Which is really "new-fangled 2-wire submersible" (my choice, matter of opinion) or "old-fangled 3 wire submersible" (avoid like plague, matter of opinion) or fancy-schmancy constant-pressure inverter-drive submersible (too expensive for me.)

Since you have a 6" bore, a 4" pump will fit nicely. Park it at 235-240 feet down the hole.