What The J said.
Civ (any version of it) will either suck you in, or leave you totally bored. Civ V is a good version to start with, because it's the easiest to win of all the Civ games. It's also got a few maddening aspects about it that (since you are new) you might not notice at first.
Good luck with the game. I suggest playing a few games at the easy level just to get a feel for the game. At the chieftian level the AI's pretty much leave you alone allowing you to build and learn the game without a lot of war. Ultimatly though, at the higher difficulty levels, you'll find you have to go to war. Playing at the lower levels doesn't prepare you for that, so that's why you should just move up one level at a time to figure out how to balance war, food, happiness, culture and science.
My rule of thumb with playing Civ is play the easy level first to learn the game. After you can easily beat the level you are playing on, move up one level. (Then simply rinse and repeat) Don't keep playing the easy level, because if you do, you'll make a lot of bad habits that will hinder you playing at the more difficult levels.
Once you feel comfortable playing the game in it's vanilla form, check out the mods. There are some terrific mods out there.
Civilization is the best game on the planet. But then you'll get that most of the folks here, hence the name of the web site.