If you look in the sound settings, you can select any of the ringtones for a text. Save it as a ringtone, and set your text sound to it. You can't have a distinct text sound per person, but you can change the text sound.
I don't see it. I went into my settings then sounds. I already downloaded ringtones. That I see. But no text/IM tones other than the stock ones show up.