Award's exhibition moves to Herbert Art Gallery and Museum as part of the year-long UK City of Culture 2021 festival