Technically it can be any graphical/editing program that you want however, most of the professional banners you see are made in something like adobe photoshop or jasc paint shop pro. Who knows, maybe you could make something out of paint.
EDIT: another good FREE program I would reccomend is Gimp or GimpShop (which is gimp made to look like photoshop)