What programs do you need to download an add-on for WoW

In general all you need for downloading and using an addon are WoW itself and a web-browser to download the addon from a third party site like wowinterface or curse.

That said, there are addon-control packages like the curse client, which allow you to download and update many addons from a central program.