'Respected and admired' Harrogate councillor dies