The show features dragons, mermaids and sea creatures and is wonderful for kids. My son wanted to go twice. Tickets cost 50MOP for adults and 25 MOP for kids but there are often promotions to get tickets for free when spending on restaurants or other entertainment in the City of Dreams precinct so do some google research before you go. The show runs frequently throughout the day beginning at midday. We visited at midday and the theater was practically empty.
City of Dreams is easily accessible by free shuttles running from other areas of the Cotai strip and hotels but is also walk able from most of the strip.