You get a watering can from the flower shop in Goldenrod City after you beat the gym leader.
How To You Sprinkle Water On The Wiggly Tree In Pokemon Soul Silver?