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.