A proposal for a new, “one-off” food and drink festival in a popular Sheffield park has been approved despite concerns from campaigners.