The Mayor of Drogheda, who became Fine Gael's first high-profile resignation over the water charges, has said he will still pay his water bill.