Big enough to fit your equipment, and I like to leave some room for any upgrades you may do later.
As well, make sure it fits under your stand So many people build/buy a sump, and the darn thing won't fit into the stand. Just not enough room to maneuver it in!