An eyesore corner site on a revamped street is set for a facelift under an initiative designed to tackle derelict corner sites in Cork.