Nation’s most unwanted dog finds fur-ever home in Yorkshire