Check the two agreements that may exist: yours with the Council that should state they are responsible for repairs and will re-instate to as good as new any damage done, and the model agreement they give to the tenant.
Also, if they will accept this, specify “the type of person allowed to rent shall only be professionals; those with no record of antisocial behaviour or drugs and no-one in the mental health system and that all prospective tenants are to be interviewed by the property owner before being allowed in the property”. You may have other criteria. I doubt if they will allow you to interview or check on prosective tenants - see the next paragraph.
The law as it affects us still applies to council tenants - the only problem is that, unless the Council Agreement is otherwise, you are not the landlord of the tenant. The Council is your tenant and they are sub-letting, so you have little or no say in what happens with those tenants: so have a thorough inventory report before you rent / lease to the Council. You still have to provide checks for gas, electrical, EPC, furniture fire resistance evidence, etc. unless the Council Agreement passes those responsibilities to them. There may be some responsibilities that they will insist on that you currently do not have to perform, like portable equipment testing (PAT).
You may still need to be a Licensed Landlord, if that scheme applies in your area now or in the future.
You must not agree to this until the Council have conducted a safety inspection: I did not rent this way because they asked me to fire proof under my stairs, put in a fire door that would reduce the risk of a fire alarm operating and being heard, all of which in my opinion increased the risk of harm to the tenants because of the design of the stairs, and these changes reduced storage space in the process!
Remember, the reason you have the property - for resale to make a profit at a future date, or for income.
Leaving it empty means paying Council Tax with the risk of squatters, deteriaration due to lack care, possible water leaks, no heating, etc.
Also, both Council and Private tenants can be awful or great or just troublesome, so it is pot luck even if you screen them first!
If it were not for increased fire risks, I would have taken the risk of using the Council - but could I trust them to fix the place up and redecorate and re-carpet when I returned home to live: some suggest “No!” That thought may get stronger as Councils need to cut back on their costs constantly and rules may change - but you do have an agreement with them, so hopefully it can be enforced in the courts.
So, talk to the council staff responsible for making agreements with you, put your questions in an email so you get the answers you need, and compare those answers to the agreement they propose that you sign, and check who has responsibility for what in the process.