The Cosmic Ultraviolet Baryon Survey (CUBS) - I. Overview and the diverse environments of Lyman limit systems at z < 1