A historic Swindon pub is reopening its doors to the public after being refurbished.