Transformed museum open after £2.8m redevelopment