Workhouse museum reopens after £2.8m refurbishment to tell desperate stories of poor