As a general rule, no. Unless you plan to overclock the CPU you can connect just one CPU power as well as the 24-pin ATX connector.
If you have space in the case for the extra cables, then connecting both will not have any adverse effects or cause the system to use any more power.