Depending on what type of pipe is leaking will depend on what types of tools and fittings you will need to do the plumbing repair. Another thing to consider is the place that the pipe is in, the harder it is to reach or access the harder it will be to repair the pipe.
Most common types of plumbing found in households are pvc, steel, cast iron, and copper. Usually copper pipe and pvc pipe can be repaired by the home owner of the leak is small enough, and most hardware stores or home improvement stores will have what you need to get the job done.
If the pipe that is leaking id steel, lead ( Lead bend ) or cast iron you will want to call your local plumber because there types of repairs will require expensive plumbing tools and expert professional knowledge to do the job properly.