The Cycling Road Guard who blocks Route 17 and asks for a drink is a Generation II exclusive. He appears only in Pokémon Gold, Silver, and Crystal. He does not exist in Pokémon Yellow (Generation I).
Pokémon Yellow (based on the anime) has no such NPC or side quest on Cycling Road. The guard simply isn't there. Generation I games (Red/Blue/Yellow) lack the "thirsty guard" mechanic entirely—it was introduced in Gen II as a minor world-building interaction.
If you're playing Yellow and stuck on Cycling Road, check for other blockers (Snorklax, badge requirements), but there's no drink quest.