I think you're on the right track thinking about content management systems. The type of client your talking about might settle for a static web page, but you'll have hundreds of competitors who can do that. You can offer a real service if you can provide a content management system that the user can modify.
The particular CMS you choose is up to you. Drupal is becoming an industry standard, but it isn't easy to learn. It does take quite a bit of getting used to.
I tend to use websitebaker for small businesses. It's open source (like drupal) but it's quite a bit simpler for me to customize. It's also easier for the user to add custom content. (My clients include farmers and balloon artists... They're smart enough people, but they don't believe themselves to be technical. I tell them if they can send an email, they can update their page with my system.)
If this is what you choose to do, you will spend most of your time creating custom themes. This means you need to be quite sharp at CSS, and a little bit of PHP and MySQL knowledge wouldn't hurt. You'll also spend a lot of time customizing graphics - incorporating their logo into banners and so on...
Flash experience is fine, but use it sparingly. Use Flash only where it helps, and resist the temptation to make entire pages based on Flash. It just adds more problems than it solves. (I like Flash: I wrote a book on it. I just don't think Flash-based web sites are a great idea.)
Dreamweaver is perfectly fine, but for CMS work, it really isn't any more useful than an ordinary text editor (and it's a lot more expensive.) When you're building a CMS, the visual design work is done by the template. You'll need to do the fine-tuning by hand. Most of the time, you'll be running Dreamweaver in code view, which means you could probably get by with a programmer's editor instead. I use Aptana for the heavy lifting or notepad++ for quicker edits (when I don't need the overhead of Aptana but still want something better than Notepad. Both tools are entirely free. I use Gimp for my graphics editing, which is also free, and very capable.
My overall advice is to pick one CMS (again websitebaker is ideal for beginners) and create your own web site with it. Build three or more pro-bono sites with the same CMS so you can learn its idiosyncrasies. At that point you'll have an impressive portfolio you can use to build your business.
Good luck to you, and stop by my site if you have questions or want more help!