Handcent SMS can do a number of different notifications like pop up text windows, notification bar, and a widget that displays the number of unread messages. It can also be configured to have custom notifiers for each of your contacts so you will know who texted you by the notifier.