We stayed at Agri-Park in Niigata for overnight.This place is run by the Niigata City and there is nothing luxurious about it.  As an adult, I would prefer a hotel with massage service at night, but for kids, they offer interesting farming experiences, including cows, sheep and goats.  They also have a large kitchen space for small children to cook and eat for food education.