CSS background attachment is a property that determines how background images are positioned in relation to their content. It offers three values: 'scroll,' 'fixed,' and 'local.' 'Scroll' moves with the page, 'fixed' remains static during scroll, while 'local' moves with its containing element. Proper use enhances design.