Tickets set to go on sale for The Steamie at Hogmanay