Growl allows applications to display custom notifications.
With Scott's Gmail Alert monitor any number of Gmail inboxes and labels.
It can be used to monitor multiple Gmail and Google Apps Mail accounts.