You need an account from http://www.clickatell.com to do it. With that in hand, go to the Growl preferences in System Preferences, select Display Options, Display Style SMS, and fill in your account details.
I haven't actually used this, so no promises...
I haven't actually used this, so no promises...