Compacts between Canada and the U. S. on the Great Lakes- between the eight states and two provinces bordering them.
A large and contentious subject.

See The Great Lakes Basin Compact-
Great Lakes Basin Compact
Not all of the 'states' have signed this compact. Big debate in Michigan. The Detroit Free Press has some 95 articles. A June 26, 2008 article, "Water protection bills near passage"- Water Bills

A rather shallow article on current debates-
Water debate

Diversion of water to areas far outside the Great Lakes area, I believe, would be a mistake. I would not presume to comment on water use in the Compact area; I don't know the region and its problems that well.
Diversion of California water to Arizona is creating problems. California's diversion of water in the southern part of the state has damaged Mexican agriculture and the environment in a sensitive region.

Artbrooks notes that water agreements must be entered into carefully. Once implemented, hard to change. Many rivers, including those in New Mexico, not only have contracts or agreements within the State, but have downstream rights granted to states beyond their borders.