Without urgent action, “the unique value of the landscape could be lost forever”, city council’s chief executive warns