Eagle: library with only common packages
The library is called ref-packages in EAGLE's lbr directory, you can copy-paste packages to your custom devices in library editor.

But be warned that you must verify package you reuse with the real device's datasheet so that it would not appear that real device is hard, or even impossible to solder because its pins appeared to be longer/wider than defined in package you reused from the library.

Pads and holes themselves are basic elements within the library editor, I do not think there're special packages for only pad of special size.