The alcohol industry should withdraw its court case against Scotland's plan to introduce minimum pricing per alcohol unit and allow five years for it to be trialled, the head of public health in the country has argued.