A man has appeared in court charged in connection with an arson attack on a house in Waterford city, which has left two children with severe burns.