The adorable pooch was "fading" in his owner's arms after the sting that could have ended the puppy's life