‘Where would the undertakers park?’ Council scraps plan to move Harrogate zebra crossing outside church