The mayor of Newport has resigned after revelations he posted offensive messages about women, immigrants and the LGTBQ community on a Facebook group for current and former law enforcement officers.