A brand new pub is set to open in just a few weeks in the former home of one of the UK's most iconic attractions.