How deep?

You likely need to be well below frost depth.

How close to foundations?

You can do just about anything by hand with a shovel if you have enough manpower.

Even smaller power equipment can make the job go a lot faster and cost less.

You might need a backhoe, or you might need a trencher. Or you might get by hiring a dozen strong backs with shovels. You haven't provided enough information to be able to tell. Location? Depth? Diameter?

How big of an area are you draining and how big is your pit?

1/10 of an inch of rain will produce 2,840gal of water per acre.