Art of international significance planned for £17m redevelopment of museum whose closure sparked uproar