Councillors approve 'much-needed' Harrogate pet crematorium