Local Correlation Models And Applications In Electronic Structure Theory