http://www.devside.net/articles/apache-performance-tuning is a good article on this topic.

In a nutshell, here are things you can do to reduce memory foot print:

1. Review the list of loaded modules, and remove the ones that you don't need or use
2. Change mpm_prefork to mpm_worker
3. Limit MaxClients in mpm config.