If you just daily the car, and don't have anything insane for the braking system... Just about anything (even the Autozone/ Pepboys/ Advance) will work for what you're after. It's only for hard driving/ autocross/ track time you need to worry about upgrading pads.

Edit: Despite how all the "regular" auto parts stores will want to upsell you to ceramic pads, they will be most likely be noisier. If the noise is your primary concern, avoid them and just go regs.