Judge resigns after drink-drive arrest