Notwithstanding the provisions of § 6-29-770 of the 1976 Code or any other provision of law, a state agency or entity that acquires real property from the federal government or from a state instrumentality or redevelopment agency that received it from the federal government shall be permitted to use the property in the same manner the federal government was permitted to use the property. Further, the property in the hands of the state agency or entity shall be subject only to the same restrictions, if any, as it was in the hands of the federal government, and no county or municipality of this State by zoning or other means may restrict this permitted use or enjoyment of the property.