Controversial plans for new motorway services off the A1(M) near Boroughbridge have been given the go-ahead by councillors.