The museum, which recently underwent a three-year makeover, has been awarded the 2026 Council of Europe Museum Prize