Is St Andrew's Day a public holiday in Scotland?

Though it has been celebrated for close to 1,000 years, many Scots are still unclear on whether St Andrew’s Day is a public holiday or not.