Building more energy efficient and sustainable urban areas that will both mitigate the effect of climate change and adapt for the future climate, requires the development new tools and methods that can help urban planners, architect and communities achieve this goal. In the current study, we designed a workflow that links different methodologies developed separately, to derive the energy consumption of a university school campus for the future. Three different scenarios for typical future years (2039, 2069, 2099) were run as well as a renovation scenario (Minergie-P). We analyse the impact of climate change on the heating and cooling demand of the buildings and determined the relevance of the accounting of the local climate in this particular context. The results from the simulations showed that in the future there will a constant decrease in the heating demand while for the cooling demand there will be a significant increase. It was further demonstrated that when the local climate was taken into account there was an even higher rise in the cooling demand but also that the proposed renovations were not sufficient to design resilient buildings. We then discuss the implication of this work on the simulation of building energy consumption at the neighbourhood scale and the impact of future local climate on energy system design. We finally give a few perspective regarding improved urban design and possible pathways for the future urban areas.