Embattled City-County councilor Stephen Clay resigns