Councillors have clashed over the future of a ban on parking motorhomes overnight on parts of the North Yorkshire coast.