The Water Pail was introduced in Pokémon Diamond and Pearl and is not available in SoulSilver. However, you can fish using rods purchased at the Goldenrod Department Store:
These rods catch Water-type Pokémon and sometimes yield rare items like Rare Candies.