Native American tribes fighting the Dakota Access oil pipeline in court have dropped an appeal against a federal judge's decision which allowed final construction to proceed.