The story
After the village in the 1947 musical of the same name, written by Alan Jay Lerner. That village appears for only one day every hundred years. The name of the village is taken from the Brig o' Doon mediaeval bridge, in Ayrshire, Scotland.
Etymology from Wiktionary, CC BY-SA 4.0.