Play custom audio alert for certain incoming mail
Assuming your using Mail.app, add a mail rule.

Go to Mail -> Preferences -> Rules. Add a rule based on your criteria (Subject Contains | Is Equal To | Starts with "xyz").

Under "Perform the following action" select "Play sound". You can choose a preset sound or select "Add/Remove" to set your own custom sound.