Water scarcity is a growing problem for rural and urban areas alike around the globe, providing an opportunity for investors, according to leading agricultural experts and investment strategists.