If you are planning on buying a tank that does not already have a overflow on it then chances are you are going to have to cut the holes out for the aquarium. You can either drill the aquarium yourself or take it to a LFS and have them drill it for a premium (call before you take it there if this is the route you are going to take. Most LFS will drill it but I am sure there are some out there that do not). If you choose to drill it yourself there are tons of videos on youtube on how to do it. If you are going to buy a overflow and want the best, most reliable, and quietest then I would suggest a
Ghost Overflow by Reef Savvy. I do not have one but would love to have one. Everything I have read about them have been outstanding and it comes will a template for drilling your tank so you know exactly where to drill at. When it comes to the actual plumbing there are several routes you could go. The most clean looking way your could go which is also the most difficult is to use PVC. If you go the PVC route make sure to use as many union connects and you can fit. The other options which is fairly easy is to use different types of tubing (I would suggest
braided nylon tubing). Regardless of which tubing you use it is much easier to use because it is much easier to cut and more forgiving if you make a mistake to fix. All you have to do to connect them is to use
ratchet clamps. When it comes to picking a pump a general rule of thumb is to have a pump that will put out 5 times as many gallons as your system. For example if you get a 75g tank then you will want a pump that puts out at least 375 gph.
When it comes to running the actual plumbing itself from your display to your sump and then back to your display most people just use gravity to run water from the display to the sump with a gate valve somewhere in between the two to regulate the flow. Then use that 375 gallon pump to run the water back into your display from the sump. Check out the
members tank section of this forum to get some idea on set ups, there are some real awesome systems with some well thought out pumping ideas in there.
BulkReefSupply - How to drill a tank