Tony Cowling investigates how local authorities are using their power to build new housing to invest in homes that are setting new standards of comfort and energy efficiency, and in the process delighting tenants and challenging perceptions of public housing