Drone footage shows £350m Co-op Live site transformation as boss reveals all about Man City and Harry Styles-backed project