Rivers burst their banks, homes were flooded and travel was hit as Wales was battered by Storm Callum.