Design And Implementation Of Quantum Chemistry Methods For The Condensed Phase: Noncovalent Interactions At The Nanoscale And Excited States In Bulk Solution