Irish hospitality is set to return to the Sunshine Coast beachfront after a $2 million overhaul of a renowned venue.