Reform councillor resigns a week after winning seat over adult film career