A much-loved café has re-opened its doors in a York village, giving its residents a community space again.