Direct observation of a local impurity induced valence transition