The firm is pulling out of what would have been Wales’ biggest energy project, a council says.