You can have multiple exchange email accounts on your iphone with OS 4 and greater.
You can also use the google mobile app for push alerts.
If you want to customize the sound the push notification makes instead of the generic beep, you can use IM+. This will work with gmail, aol mail, msn mail, and and many other accounts that have instant messaging.