The Beano’s creators and characters are to be the focus of a major exhibition this autumn