Three people are feared dead and thousands have been left without power as Storm Ophelia lashes Ireland and parts of the UK.