To choose ringtones for each contact just open the contact, choose edit, then scroll down to ringtone and select a new one.

SMS, alarms, and email notifications all have to be put in the \windows\ directory or my device\application data\sounds folder.