If you live in a council house or flat, then YES, they have to approve ANY pet you may wish to have.
However, if you live in Scotland and live in your own private house, flat or whatever, you do not need council permission to own/keep a "pet". Prior to 2002, every property deed in Scotland was very strict and heavily controlled by the local council and local land laird {"lord" in the rest of the UK}. In 2000, the Scottish Parliament passed a law that abandoned most of the Nazi'ish deed restrictions placed by the local councils on private property.
If you live in a private flat, you will probably have deed restrictions placed there by the home owner association or the building management/owners.