First-Principles Modeling of Non-Covalent Interactions in Supramolecular Systems: The Role of Many-Body Effects