A Queensland council was forced to install the signs following reports of a 'confronting' trend in a popular rose garden.