Fine Gael Senator Brian Hayes has become the latest Oireachtas member to resign his council seat due to the abolition of the dual mandate.