A local authority chairman has admitted to being “sad and disappointed in myself”, but said his “integrity remains intact” after he forgot to cast his vote in a council leadership battle.