Civ V won't let me destroy other cities

You are unable to take a city via a normal ranged unit attack command. You will need a unit that can actually invade the city itself to gain control over it. Some say you can use the move command if a cities health is low enough but I haven't actually ever tried that. The best way I know of is to use a melee unit to invade the city after you have its health down low enough.