Plans to develop a tourist attraction at one of Cork City’s most panoramic locations have been shelved.