Go to the market and download handcent sms. Then you just need to go into the native messaging app and turn off notification and automatic download of messages. Handcent allows you to set up selected tones for each contact. It will also solve the issue of the phone sending to the wrong contacts as has been happening some with the native messaging app.
have fun