Climate Change Advisory Council’s latest report warns of requirement sustained investment in climate resilience