Uniformed officers from North Yorkshire Police will no longer be able to take part in Pride events, the force chief has said.