An Edinburgh landmark that has formed part of the city’s skyline for over 120 years has been transformed into a new community greenspace.