San Francisco hospital CEO resigns amid patient abuse scandal