In Johto in Dark Cave

First you must defeat Pokemon Trainer Red (The highest levelled trainer in the game) then talk to Mr Pokemon on Route 30 in his house

You need to give it a water stone.  Apparently 2nd place in the bug catching contest gets you one.