Dreamweaver is the bees knees, but you may not want to make honey. For designing websites, there are some cheap and/or free packages, some of which are quite good. I use a prehistoric one that's now extinct, so I wouldn't recommend that.
DON'T use the Microsoft thing (FrontPage, I think it is still called). My daughter did a whole load of webpages using that, and found that only folks using Internet Exploder could view them. Then her ISP dropped FrontPage Extensions and they wouldn't work anyway.
I use Fasthosts to register domains (I have an absurd number). That's dead cheap, and they all redirect to my "real" ISP. Each domain links to a different "front page", all on the same server.
The ISP I have (an Entanet reseller) provides MySQL support and all kinds of other stuff. I don't know what the bandwidth or webspace limits are, but they're more than I use.
For uploading, I prefer FileZilla: it's a very nifty FTP package, and it's free.