First you'd need the alert audio file (I use Zedge for that). Then place the file in the Notifications Folder and you can select it as your text tone in the Settings. As for the unlock sound, I don't think you can change that one without root or changing your locker.