Renovating or building from scratch:
Make sure that your multiple sinks have their drains plumbed separately. That way the milk you pour down the drain in the dairy sink can’t come up through the drain in the meat sink and cover meat dishes, etc.
Most plumbers will simply use one waste line fed by both sinks; spend the extra money and avoid problems.
We actually have three sinks. There are meat and dairy at opposite ends of a 12 foot island, and there is a pareve sink with disposal on a side counter used for fruits and vegetable prep.
Pesach is not an issue as we have a separate Pesach kitchen