No, there is (currently, which I think includes the upcoming Windows Phone 8 version of the OS) no option that enables you to do what you want with selective notification sounds for emails based on the content or other properties of a received email.