I haven't been able to read through all the messages but in case it hasn't already been said, be very cautious about following your friends paths of lying about your partner living there.
Many HAs and Local Authorities will offer you a fixed term tenancy and at the end of the review period (which can be anything between 2-5 years) will assess your housing need once again, if you're not deemed to be in need of social housing any longer they can ask you to leave.
Picking up on one comment made by a poster, Housing Associations allocate nearly all of their properties via the housing register held by the local authority. It's only in areas that may be hard to let that the HA may hold their own waiting lists so I wouldn't say that going direct to a housing association will help as they'll just refer you back to the council.
If you can afford to privately rent, you should consider that, or possibly shared ownership.