A variational approach to two-body correlations in finite nuclei