Local councils unprepared for climate change, report finds