End in sight for Ripon city centre potholes