Moody defied family expectations to pursue his art, and is now celebrated in an exhibition at The Hepworth Wakefield