Mail.app notification filtering
You should be able to do this by setting up Rules in Mail.app that filter on the criteria you desire and then run an AppleScript that triggers a Growl notification. Rules are setup in Mail.app under Preferences…->Rules.

Growl can be called from AppleScript as shown here.