What did the speckled band drink?

The Speckled Band, from the Sherlock Holmes story of the same name, did not drink anything. It was a venomous Indian snake, and snakes don't drink like humans do.

Perhaps you're thinking of the victim, Helen Stoner, who was the one who was poisoned by the snake.