You can assign distinctive ringtones to people in your contacts list for audible FaceTime caller ID. You can also assign distinct tones to alert you of a variety of other events, including new voicemail, new mail, sent mail, Tweet, Facebook Post, and reminders.
You can purchase ringtones from the iTunes Store on iPad. See the iTunes Store section.