@Matt.Johnson - As you point out, coulcils can make any safety rules more restrictove than the G2SS they choose. They just cannot waive anything in the Guide.
Although it is odd, in my council, a Cub Scout cannot camp on council property with a parent. They even apply this to Webelos. They can easily enforce it at check-in. However, they have no such rule if a pack or Webelos den is camping somewhere other than a council property (on a council-approved list of camping locations). It seems counterintuitive to me, because if I had to pck the safest place for a Cub Scout to camp (and, therefore, the place where the assistance/proximity of a parent is most needed), I would say it is a council property that is, after all, designed for Scouts.