Yes, it will take YEARS of work. (Game developers are programmers with very serious experience, and are paid 150k/year!)
Your very first problem is to decide WHICH game engine you are going to use.
Game engine????
A game engine is a piece of software that "motors" your game: it is the core of your system. You can write your own, but it will take you the rest of your life. There are many game engines available on the web (just google "game engines", or go to www.devmaster.net/engines.)
Choosing the engine is the hard part: get the wrong one, and you loose years of work! (I took Adobe Atmosphere a few years ago, worked three years on it, then Adobe discontinued it!!!)
Ogre seems to be a good one (and it is free...)
Once you have the engine, your work begins...
You have to buy/download many programs to design/develop your scenes to import them into the engine...
I won't go any further.
Choose your engine first. Call back later!