This is the best Bond movie ever made - it has a great Bond, a solid plot, a convincing villain, a marvelous cast, some incredible action sequences, a witty script, and plenty of intensity and suspense. It's also one of the grittiest Bonds, so I would recommend it for teenagers and up. As per a usual Bond, there is quite a bit of drinking.
Violence: in the opening sequence, two men are shot at close range in the head - this is a black and white sequence. The first one there is no blood and we simply see him fall back in his chair from a distance. The second, we see it from his point of view, with a copious amount of blood dribbling down the screen. The film includes plenty of explosions, bullets, and hand-to-hand combat, often brutal. Bond shoots many people and we usually see a brief bit of blood. A man is strangled rather graphically. A woman drowns - this is probably the most emotional drowning scene I've seen in a movie. A man is shot in the eye with a nail gun - we briefly see the nail protruding from the lens of his sunglasses. A man is electrocuted very briefly. The villain beats Bond's genitals with a knotted rope.
Sex: Bond and a married woman kiss passionately on the ground for a while, but he leaves before anything more happens. Bond and Vesper kiss passionately and fall to the ground - sex is implied. In one scene, we see them naked in bed with sheets covering anything graphic. There are lots of women in skimpy clothing.
Language: M says "h**l" a lot. "D**n," "b*****d," "b**ch," religious profanities, and other swear words are used infrequently.
What other families should know
Too much violence
Too much sex
Too much drinking/drugs/smoking