Mac Mail: How to have mail popups show for only a couple seconds
As mentioned you can change the Notifications settings in Notification Center. 

You have the Mail alert style set to alert which makes the notification stay until dismissed. 

To make the notification disappear after a few seconds you need to change the style to banners in Notification Center.

Shown below: