One of Yorkshire’s most well-loved museums is finally set to reopen its doors in January, some 18 months after being closed for a major refurbishment.