I use Macromedia's stuff daily, and I love it... I am an intermediate programmer, though, and that does come in handy sometimes for more advanced web things like JavaScript and PHP.
It helps to have some sort of background in design or layout or something. If you can't sit down and sketch out a design that looks decent with pencil and paper, you're not going to be able to make anything visually appealing, so you may want to decide if visually appealing is important, or whether you'd just want to focus on the content.
It also helps to know screen measurements and basic stuff about resolution and pixel size.
I wouldn't get the Macromedia software unless you're willing to put some time into learning the programs, so if you just want a one-off solution for this website only, I recommend skipping Macromedia's stuff.
There's a program called "FreeWay" that gets some decent reviews and is supposed to be targeted at both advanced and beginning web designers. It's $250 for the Pro version, but they also offer "FreeWay Express" for $89. They have time-limited demos at their site:
http://www.softpress.com/en/freeway
(just click on "Downloads")
Another option is to have a designer put something together for you, if you just want a website but have little interest in actually putting it together. I know of one in particular that would put something together for free, in exchange for the right to link to it from a portfolio website. (wink wink)
Either way, I think you should at least check out FreeWay. It sounds decent and got some good reviews, and $89 ain't that bad if it turns out to be great.