No, I'm pretty sure you mistook gal/min for gal/day... 330 gpd is .22 gpm, 1/10 of one usage point (a single sink is 2.5 gpm). Water pipe sizing is done based on flow rates in units of gpm.
But let's back up here a little: The tone and nature of the question imply some disturbing things with serious legal implications that we need to get clear. The tone and nature of the question implies you have little or no engineering experience and are not working directly for a registered professional engineer. Perhaps you work for a developer who doesn't want to spend the money to hire an engineer? The task you are doing is one that in most places in the world is required by law to be done by a registered professional engineer or by someone in direct supervision of a registered professional engineer. If you aren't following the legally required engineering process, I highly recommend you re-examine the process you are following. The legal liability involved in doing the work illegally and making a mistake on this (like sizing a water pipe based on two orders of magnitude too small flow rate...) are vast. This particular problem involves exposure to several million dollars in legal liability in addition to loss of operating licenses, which together would force the closure of even a medium sized construction company.
Now, the nice thing about plumbing systems is they, like electrical systems, are designed mostly by the code (unlike air conditioning, which isn't required by code to keep a building cool). So there is no ambiguity to the design process either. Here's how it works:
1. Get yourself the relevant code book, probably the International Plubming Code.
2. Build a flow diagram of the complex's piping infrastructure layout.
3. Start from inside to out, building a spreadsheet for required flow rates from each house, cluster of houses, etc. The code book has tables of required flow rates to assume for each usage point and diversity to assume based on house size and number of houses on each main. Just plug and chug - it is a half hour exercise, tops.
The second task is then to size the pipe. You need the flow rate you just calculated (perhaps you already have it if you just got the units wrong - 330 gpm sounds about right), but you also need to know the pressure of the water available at the utility connection (adding pressure for the height of the buildings and difference in height from the utility entrance to the houses). Typically, you would want to design for an absolute max of 10 fps in the pipe and 10 ft/100ft of pressure loss (I'm not going to explain those units/terms: if you don't know what they are, it emphasizes my point that you need to hire an engineer). There are lots of books out there with tables/graphs of gpm vs pressure drop for pipes (probably on the net too, but never looked). But those are just rough rules of thumb - if you don't have much pressure available, you might want to size the pipe for less pressure drop. Or you may need to design yourself a booster pump.
How much static head you need at a faucet depends on how generously sized the piping is. Ie, 50 psi should be plenty if you have well sized pipes, but if you don't, it might not give you enough flow.
Just a little more emphasis on the point that you really need a qualified engineer to design this: if you size the pipe for 4" and it needs to be 5" (for example), that's only 20% too small in diameter, but 36% too small in area (and therefore too high in water velocity) and your pump will end up 74% too small (1/4 the size it should be).