Updated: The married seven-term New York Democrat's resignation would end a once-promising career as a leading liberal voice.