Yes as 11B1P said, you need to be running GDR3.
With that on your Phone you can use the People Hub to set custom sounds per contact for Ring and Text Tones.
Sadly you can't set per-contact tones for Email, but you can change the generic email tone to whatever you wish.