Demolition of long-standing Ripon eyesore finally approvedResidential plan for semi-derelict Ripon site