The exhibition at the Holburne Museum will look at how the artist known for his grand public sculptures also worked on a much smaller scale