Diageo has been given the green light by councillors to build Scotland's first major distillery in 30 years.