Self-consistent local GW method: Application to 3 d and 4 d metals