Here are some good links on how to install a server farm, not just a standalone of MOSS 2007. The average medium server farm is two web front end servers with load balancing. To configure load balancing, here are some resources, look at the links at the end of this post:

What to do in SQL 2005: http://www.datasprings.com/Resources/ArticlesInformation/OverviewonInstallingSharepoint2007/tabid/774/Default.aspx

http://sharepointkb.org/Install_MOSS

http://blogs.msdn.com/joelo/archive/2007/01/05/nlb-network-load-balancing-and-sharepoint-troubleshooting-and-configuration-tips.aspx

Here's the instructions for installing the farm:

http://www.sharepointforum.com/en-US/Wiki/Installation%20MOSS%202007.aspx

To summarise the steps, they are:
Create the service accounts
Install SQL Server, make sure named pipes is enabled
Complete install on first server, new server farm
Install second and third servers, join farm
Make first server run Excel services and indexing. If you have another app server, better not to have indexing and central admin on one box. You can run config wizard again to recreate central admin site though.
make 2 WFEs the WFE and search/query servers.
Create SSP and My Site Web Apps.
Create default user Web App, if you do not have NLB set up yet, put URL as NetBIOS of a WFE. Not ideal that
If you have NLB, put in those as the URLs all the way along when doing WFEs.
Set regional settings, usage analysis, indexing, profile index, search usage reporting.