The Clean Water Act has allowed states and tribes to derail some high-profile projects. That power will be diminished with new rule, say environmental advocates.