North-east care home destroyed in fire sold by council