Water cannons could fill a "gap in the armoury" of police in England and Wales to help them deal with riots, according to the president of the Association of Chief Police Officers said.