Demolition of long-standing Ripon eyesore finally approved