The dog, named Comet, was found with what the RSPCA believe to be stab wounds