It basically depends on the purpose of the website ,

Like if you are intrested in simple HTML/DHTML websites the following tools may help you in nicer way.

*) Macromedia's Dream Weaver, FireWorks, (for Imaging : Adobe Photoshop)

If you are intrested in Animated / Multimedia sites than

*) Macromedia's Flash

If you are intrested in portal/Database / Query Oreinted sites. you need to use the back-end either it may be SQL/VFP/Access/Oracle or any other back-end engine you can take help from ASP tools like,

*) Macromedia's DRUMBEAT 2000 (it's really good)