A picturesque village gifted lands by Cork County Council will be transformed with the development of a former “eyesore” into a scenic park with sports facilities and a playground.