The place where Mary Queen of Scots sought shelter before being executed is to become the stage for a festive light show.