If you are using gmail, I know you can install Handcent and pull it off. Probably a number of other ways.
In gmail, settings, select the account, Sound and Vibrate, click Sound, then use Handcent when it asks what program to select to the ringtone. You can pick any .mp3 on your device.