No. There would simply be a guy sitting on his front porch drinking a fifth of Jack Daniels with one hand, and maybe his shotgun in the other. No army necessary.
You see, our rights are inalienable. No one can take them away from us. While a state or county may have rights over the Federal government, they have no rights over the individual. Where the state outranks the Fed, the individual outranks the state/county. Laws that violate one's rights are unconstitutional, and may simply be ignored. A county may pass any "dry" law it wants. It is automatically null and void, because I have a right to drink, buy, or sell booze without government permission.