A manager who refused to take a "for cause" drug test was fairly dismissed because his employer was entitled to expect him to set an example for other staff, according to an employment tribunal.