2 of 2 added 112 characters in body

I would simply turn off email sync for those accounts specifically. You can do that by going to Settings -> Accounts and sync, selecting the account, and unchecking Sync Gmail. You can still check mail manually through the GMail app, of course.

Edit: The newest version (2.3.5) of GMail now supports turning off alerts for particular GMail accounts.