Openly gay Jewish Democrat, a member of the influential House Middle East subcommittee, leaving politics to take up position as CEO of Rhode Island Foundation