A senior police officer in the UK who headed a roads policing unit said he has "let a lot of people down" after he was filmed using a mobile phone while driving.