A man is fighting for his life after being shot at a house in a quiet County Durham village.