Spin fluctuations in nearly magnetic metals from ab initio dynamical spin susceptibility calculations: Application to Pd and Cr95V5