Freshwater lake depleted by droughts, rising temperatures and over-pumping, but authorities hope project will help keep reservoir full, while boosting ties with thirsty neighbors