Betsy was the RSPCA’s longest-staying dog in the north of England