Up in the Appenine mountains, 2 hours drive from Bologna is a beautiful spot outside the village of San Donato, where Villa Poggio Bello has a beautiful vista.
The villa is well appointed for a large group - we travelled as two families with 3 children in total. Unfortunately as the weather was wet and cold in May we couldn't use the pool (unheated) so had to travel down the mountain to the coast to get the sun or (1.5 hr each way) or the same again in the opposite direction to visit Umbria. Local shopping was done in Santa Agata and the daily markets in various towns. The location is also ideal for walkers and cyclists. I can imagine in the good weather months it would be perfect as one could stay put and use the pool whilst soaking up the amazing view.