500 m is equivalent to 50 bar ...

500 m is equivalent to 50 bar net operating pressure, so theoretically one well designed and manufactured pump could do this job. But you need to specify the exact volume of water  to be pumped, e. g. in m³/day to cover the daily demand, or as peek value in m³/h. Is there treated wastewater available at this location ? Could allow to address a pressure exchange system. with very low electrical energy demand. But as "each case is different", what I call the "golden rule of chemical engineering", more details are necessary, including the questions "voltage at the near grid ?", "who pays ?" and "are there funds for consultancy support ?".