Unless you've got a booming system with several large subwoofers, you aren't going to excessively drain your battery by listening to the radio with the ignition in the accessory position.
For A/C, take the kids inside. For dogs, park in shade and get an accessory window fan. On all but the hottest days (L.A., Phoenix, and similar places excepted) they'll be quite comfortable.
I leave my dogs in the car all the time. They're in the shade with great ventilation. They're unstressed and content in a space they consider home.
People freak out when a dog is contentedly sitting in a car on a 60F day. Don't be one of those people.
However, many vehicles are such configured that in order to have any amount of power available, you need to also power up the daylight running lights, fuel pump, internal computer and other consumers that quickly add up and can indeed drain a battery in a few hours. There needs to be more awareness from the car builders about the need for an eco, long lasting ignition option that you can safely use without risking battery discharge.
On almost all cars the aircon compressor is driven by the engine, not an electric motor, so the motor needs to be running to cool the air.
The fan that blows the air through the vents is electric, but the air coming out will only be ambient temperature if the motor isn't running.