Titled Farting Cockatoos, the creation has transformed a prominent piece of vacant commercial land, which its owner admits was an "eyesore" before the installation.

At 45 metres long and 1.8 metres high the artwork at 199 Macquarie Street is visually striking and its use of sound reportedly has some viewers reaching for their mobile phones to make recordings.

Creative director for the initiative, Dubbo-based artist Jack Randell said the artwork was "a bit weird, a bit funny" and one he hoped would provide people with a "sense of wonderment".

He said "invariably positive comments" had come from passers-by who had activated the artwork's hidden motion-detecting device to let off a raucous soundscape.

The artwork was also making a splash on social media, achieving 150 'likes' in its first 24 hours online, Mr Randell reported.

The artist said he had the idea of bringing the nearby Macquarie River to the main street, which had historically been built with its back to the waterway.

"Whenever you go to the river you almost always hear the cockatoos," he said.

Brett Anderson, managing director of BAWD Property Trust, said they commissioned the artist to provide a "practical solution to something that was an eyesore".

"Our hope was that it would be uplifting and help spread happiness, raising the energy of our site and the CBD generally," he said.

The idea started from Dubbo City Council's Ignite Our Centre campaign, Mr Anderson said.

BAWD Property Trust commissioned the artwork for a cost "in the order of $5000" and the managing director advocated public art as a way to add value to commercial property.

"We fully believe public art can have a positive impact on property values and business profitability by giving people a reason to visit a location," Mr Anderson said.

"I'd strongly encourage property owners to consider any form of public art."

Children and their grandparents were among to look, Mr Anderson said.

"Another couple walked past and pulled out their mobile phone and started recording, including the sound," he said.

As for the land, Mr Anderson hinted at a new future for the long-disused site.

The artwork was only temporary, he said.

"We're working on some things at this time for the site," he said.

"We're looking to do something on the site in the next 12 months, maybe not all the site, but part of it."