Final Harrogate borough mayor takes office