Health and Adult Social Care director leaves council