The Mayor of Drogheda has announced that he is to resign from Fine Gael in protest at the Government's handling of the water charges controversy.