The the best looking website you'll want to get a copy of Flash. It's kind of hard to use at first but once you understand how it all works it's a lot of fun.... but that's a bit expensive... Dreamweaver is a easier to use alternative but isn't as cool...
A cheap and easy way to make a site would be to create all your pages in Photoshop or something, keeping it all in layers - hiding each of the layers when you are done creating them, then exporting them into sliced images and using GoLive or something to produce all the individual pages... just link them all together and you'll have a sweet looking site. What do you do for a living? I'm sure your job has a copy of Adobe Creative Suite installed on a computer you can use for a few hours...