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