A pail is a type of bucket. "Pale" is a homophone of "pail". When someone "turns pale" it means that their complexion looks washed out and without color. The joke is playing on the phrase "turn pale" but replaced "pale" with "pail" because they're talking about a bucket of water.
Drinking a whole bucket of water could make you turn pail .