No, it is prohibited to drink alcohol in public parks in Dubai. You can see all the rules around drinking in Dubai here.