In Pursuit Of Local Correlation For Reduced-Scaling Electronic Structure Methods In Molecules And Periodic Solids