Apple has just released a new section in the iTunes Store that lets users buy text and alert tones. While the store has always featured ringtones, the alert tones feature is new and requested among many users. You can access this new store by going to Settings > Sounds > Buy More Tones. This was hinted at a few weeks ago.
Ringtones are listed for $1.29 and alert tones for $0.99.