Borewell and pumps

Which pump to use for a 300 feet borewell with average yield?

I put 300 feet borewell, in my area yield is moderate... is there any submersible pump with less output power for 300 feet borewell? I'm hesitatant to use compressor as it is noisy. Please suggest.