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.