The region's school estate has been branded "unsustainable" due to falling pupil numbers, ageing buildings and a struggle to meet carbon targets.