Ultimately, as a member of a legislative body, if you don’t like the way the executive bodies charged with inplementing a law are doing so, your choices are:

(1) Work with other members of the legislative body to hold the executive accountable for failures, via hearings, sanctions (often, if at the same level, including removal), etc., or

(2) Work with the same body to file a lawsuit as a body to compel compliance, which has additional enforcement provisions (including contempt orders by the court for noncompliance) not available with the bare law and no court case,

(3) Taking any avenue open to the public at large (including individual lawsuits, public advocacy including including electoral advocacy against any elected executive officers involved, etc.).

What is not generally an option is unilaterally assuming the role legally assigned to the executive in inplementing the law, or simply assuming whatever other powers you imagine are best to realize the intent of the law even if they are outside of its letter.

> Who enforces it then?

The executive can enforce judicial orders. This is civics 101.

> The local law banning it was already equally as valid as a court order

The ban is an ex post facto law. Rights holders to property have a legitimate reason to defend those rights across policy changes.

The court enforces it. We're getting into movie plot politics here. The sheriff's department will not in fact ignore a district court ruling. These scenarios rapidly reach the point where the sheriff is removed from office and imprisoned for some amount of time. This is what happened to Joe Arpaio.

This is much simpler in a municipality: the board simply fires the village manager and the chief. A sheriff is usually an elected though.

Before you reach the point of suing, you cancel contracts, payments, IT infrastructure, and have public works remove the cameras from any county-owned infrastructure.

I mean, all this is pretty silly, though, because what you really do is just turn the cameras off.