Handcent will change just text notification ringtone. So you can have a ringtone that is different from emails and such notifications.
PP, to set up Handcent to where it only receives notifications, go to MESSAGING then Settings, and uncheck Notifications.