Solar-driven borehole for sustainable water supply