The poor dog’s last goodbyes lay beside his sister in her final moments, comforting her and refusing to leave half a step