Waterford City and County Council is to demolish, within weeks, a derelict 113-year-old grain store on a quayside site earmarked for a €300m development project.