Scottish council appoints man as "period dignity officer"