Parking restrictions in two York streets near the River Ouse have been approved to improve safety and free up spaces for residents - despite concerns over access for visitors.