Is there any way to get a pop-up notification on my iPhone or iPad when mail arrives?
With the release of iOS 5 mail can now appera as a pop up box style notifacation.

Goto Settings>Notifications>Mail> the choose "Alerts" in the alert style menu.



you will then have something that looks like a message notification when an email arrives