Hepworth Wakefield, Tate and the Arts Council Collection among those who have new works following the event