Derelict Glasgow land will be transformed into a lush new 15-hectare community greenspace under a new council plan.