Thanks for your interesting topic and I hope the visa extension works well for you. I am curious, not having been to UK so many many years, what is this city council accommodation you were hoping for - is this like a homeless peoples assistance?
I always thought one had to book in a hotel or bnb if one had no home to their name, but as you say you couldn't afford it?
Anyway best of luck.