Residents who complained about the possible noise and dangers are celebrating but the party boat organisers say it is a missed opportunity for the city