If your remark is not tongue in cheek, the best place to source the water is the furthest down the St. Lawrence River which is still freshwater.
Seriously, it would probably be cheaper to desalinate water from the gulf and pump it north.