Former council director wins substantial pay-out