My favourite solution to water scarcity is water traps. It seems like such an amazingly simple concept with underrated potential:
Make sure that whatever water rains down in a place stays long enough to nudge the micro-climate in the right direction - by digging some water barriers in the right places.
While it cannot possibly(?) solve water shortages everywhere it can turn some deserts green: