At a time when mid-sized galleries are suffering from hasty expansions, Herald St Bologna reflects a more sustainable attempt at growth