If the ice caps melt due to rising temperature surely this means more water in the atmosphere and more rain in some places?

Over about 20,000 years of the water cycle, yeah.

Ideally we'd want a water solution that didn't involve carting incalculable amounts of rainwater across the countryside...