This will come down to personal preference depending on skill set and technique.
Weller is the best you can get with Hakko coming to a close second. Stable adjustable temp control is a must.
I have an older Hakko soldering station (Hakko 936-12) with a few different size tips and have had reliable service from it for many years.
As I've aged, I've found I needed a magnifying lamp as an essential piece of gear for soldering boards (of course YMMV).
This will give you professional results. There are some cheaper hand held/pencil type Weller units out there that you can get (with a couple different size tips).
How much were you willing to spend?
Some suggested items you need are:
Soldering Station with a few different size tips
Holder/Base
Magnifying Lens (lighted preferred)
Tip cleaner
Alcohol (for cleaning/board prep)
Flux (I like the liquid over paste)
Flux remover (I like the spray cans)
De-soldering tool
For your convenience I've attached some links for you to look over below. Perhaps others can chime in as well with their experience.
http://www.amazon.co... soldering iron
http://www.amazon.com/Weller-WP25-Professional-25Watts-Soldering/dp/B000B63BTU/ref=sr_1_7?s=industrial&ie=UTF8&qid=1350404873&sr=1-7&keywords=weller+soldering+iron
http://www.gotopac.c...tion_s/3893.htm
http://www.amazon.co...pd_sbs_indust_3
http://www.amazon.co...&keywords=hakko
http://www.amazon.co...LOURESCENT LAMP
http://www.amazon.co...n/dp/B000BRC2XU
http://www.amazon.co...esoldering tool