From the UK’s largest sports stadium to a world-record Passivhaus, the scale and range of construction projects planned and under way in Greater Manchester is testimony to the city’s boom. Kristina Smith reports