Auckland residents support proposed $1b climate rate, council says