Well water or water piped in (city water),what are the pros and cons?

My fiance' and I plan to build a home in NORTH CAROLINA..I'm originally from NJ he's from NC..I don't know anything about wells ,other than children falling in them.I heard something about fluoride content and that's about it.Tell me what you know .ELIGHTEN ME ,PLEASE!
6 answers 6