'Historic’ water rights agreement signed