Honestly and with all seriousness, unless you have a burning desire to learn HTML, CSS, DHTML, Javascript, PHP, MySQL and/or XHTML, you should just save yourself the headache now in both time and money and hire someone to do this for you. Even with the WYSIWYG editors, without having some basic understanding of web coding, you will have a difficult time getting the results that you see in your mind. I have several thousands of hours in web design experience over the last fifteen years, both with CMS scripts and with coding by hand, and this is probably the best advice you are going to get on this subject, even if it isn't what you want to hear.
A site like the one your signature points to
could be done with Dreamweaver and Fireworks, by someone who knows what they are doing with those programs, and would require some basic HTML and CSS understanding along with some form of database or DHTML knowledge for the interactive elements like the guestbook. Without having HTML and CSS knowledge, this type of site would be much easier to accomplish with a CMS like Wordpress or Joomla and the proper plugins, yet again by someone who knows what they are doing with those scripts. The reason people keep saying so is because it is true.
I'm just giving you honest advice. What you are asking is similar to asking if Ableton Live can help compose a song that you have in your head. The answer is "yes"... but it is going to take at least some knowledge of music and recording theory to do so.
Dreamweaver is a very deep application, at least as deep as Photoshop, and is going to have a steep learning curve. Even if you never hand code a single HTML text line and only use the WYSIWYG editor, there are going to be formatting errors which are going to require some basic HTML and CSS knowledge to fix, even if only to figure out what the problem is and to know what to look up.
If you are determined to do this yourself, and are on a PC, my next advice would be to really learn either Wordpress or Joomla and find a good template, whether free or commercial, which is close to what you want, and install plugins to do the features like streaming media and the guestbook. There are non-bloggy themes out there, you just have to look harder - I speak from experience.
If you are on a Mac, strongly consider using RapidWeaver or iWeb. Those are the only two web design applications I have worked with which allow someone with zero web coding experience to build a really nice site. My wife knows very little HTML and CSS, and applications like Photoshop and Dreamweaver give her a headache just from their interfaces; yet she can design, upload and update a quality site in Rapidweaver easily, without my help.
And finally, if you do choose to go the Dreamweaver route, invest in a video tutorial or book to speed things up, like at designprovideo.com or lynda.com, along with a Basic HTML / CSS book, video or website to get the basics; along with a couple pounds of quality coffee.
Edit: You don't need Fireworks, it just makes web formatting of images easier. Photoshop and Dreamweaver can do it all.
Now that I think of it, my friend Ariana does this kind of thing professionally as a side gig, and is quite adept with Photoshop based web design.
http://www.arianasaraha.com/citmatrix/