Europe's largest tidal current energy project has been given the go-ahead by the Scottish government.