The show at the Royal West of England Academy in Bristol will explore the little-known artist’s remarkable life and career