Can I succeed the secure tenancy of my father/mother, uncle/aunt, grandfather/grandmother, cousin etc. after their death?

Yes, you can but you have to provide documentary evidence to the relevant Council such as birth certificate to show that you are indeed their relative. You have also to provide documentary evidence to show that you have lived in the property in question for 12 months prior to the death of the relative in question.