A new wheeled rubbish bin collection policy has been approved by North Yorkshire Council despite concerns about its implementation in coastal areas.