Well you can wallow in it being your own fault, or you can follow up some of the suggestions upstream.
Unless you have significant savings you haven't mentioned, you're unable to buy a property and you're unlikely to get a private let due to all the reasons mentioned. You have no friends or family to stay with. Making yourself intentionally homeless would be an incredibly unfair thing to do to your daughter (and isn't an option for you, due to a puppy).
Do you have savings that could be used as an additional damage deposit allowing you to try to find a private let? If not, are you able to save?
Currently, your best option is to make life bearable at home, minimise your risk from the neighbour, and continue trying to move via the housing association:
- Continue no contact with the neighbour. If you don't want him in your garden, you can request he no longer uses the tap via the housing association.
- Expand your search for a swap with the housing association to smaller properties and/or a wider area. Call them and see what they can offer and where. Have you done this?
- Make your house a more appealing prospect by decorating / clearing up so any people who view are more likely to want to swap
- Stop drinking; your behaviour when drunk is unacceptable
- Continue working with mental health professionals and taking your medication. Stop forming unhealthy relationships with men until you've sorted yourself out. Prioritise your daughter. Take some responsibility for yourself.
Sorry if that sounds tough OP, but you live in a country in the midst of a housing crisis. No-one can up and move instantly for free.
If you feel you or your daughter are in any actual danger at any time, you need to call the police.