New Orleans city councilman resigns