Designed to fix the territory’s dire water shortage, the scheme to turn a sea inlet into a reservoir was described by the SCMP as one of the world’s major engineering feats