After you banish a Farming Village, the rest of the card’s effect does not take place, and you are unable to get a City. The Farming Village is still banished. (The same is true if you banish a City and there are no Large City cards left in the Market.)