No; most council tenants are secure, which means they can only be evicted in certain situations and are therefore in a lifetime tenancy for as long as they want.
However, if you are in an introductory, flexible or temporary tenancy, they may request you to downsize. However, this will be clearly explained in your contract which states what kind of tenancy you have and what this means.