City ruins are the remnants of a destroyed city. In Civilization IV: Beyond the Sword, they are formed when you, an AI civilization, or barbarians raze a city. They are useless and can be replaced by an improvement.
Sometimes a random event occurs that says something like: "Scientists have found valuable information buried in the city ruins near <city name>." This event gives a boost for the technology you are researching.