The Olympic bid appears to be over as 56 per cent of voters said No in a plebiscite held only two weeks after a public funding deal was struck