You know that classic zelda chime which plays in twilight princess, among others, when you solve a puzzle? anyone has that one? would make an awesome sms-chime ;)

This place has a bunch of the sound effects from Zelda games. Should be able to find your preferred version there.
http://noproblo.dayjo.org/ZeldaSounds/

http://www.megaupload.com/?d=JN20DXRL

Emperor ServingSpoon beat me to it thanks to my browser, but here's a version of it if you'd like.