More support and funding is needed to help local governments cope with the costs of climate change, a new report has found.