Hi LUGZ. Welcome to SitePoint.
I'm starting to feel a little overwhelmed by the ever growing mountain of required knowledge I'm going to have to possess in order to do this as a profession.
Don't worry, these forums attest to the fact that many people make a living out of web design without knowing much about it at all. :x
HTML and CSS are a good start, but as you say, more is really needed. Don't panic, though. While knowledge of JS is ideal, you can get away with using pre-made scripts like jQuery that do most of the common things, so fancy effects like popup galleries etc. are plug and play and free, too.
And although things like PHP and SQL are important for dynamic websites, there are many CMSes available that have this all done in advance for you. So even if you are going to learn PHP etc. properly, you don't have to do so before you can create fancy websites with lots of bells and whistles.
So my suggestion is to keep refining your HTML/CSS skills, learn how to use jQuery (the essentials will take you an hour at most) and pick a good CMS that will be able to handle most of what you envisage doing. Spend a bit of time learning that CMS and how it works, so that you know you can provide a website with plenty of functionality, even if you don't know how it all works. (Let's face it, most people don't find out how a car works before they entrust their lives to it.)
Then, knowing that you can build cool websites, gradually learn more about JS, PHP and the rest, in order to gain more confidence and power to do what you really want to do.
That's my approach, anyhow. I'm currently working on the JS part ... slowly.